package com.jiazhong.cloud.gateway.example.gateway.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.jiazhong.cloud.commons.bean.Power;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface PowerMapper extends BaseMapper<Power> {
    @Select("select * from power where id in(select power_id from student_power where student_id=#{id})")
    List<Power> findPowersByStudentId(String id);
}
